<?php
class Lion_View_Helper_Footer extends Zend_Controller_Action_Helper_Abstract
{
    private $_view;
	public function setView($view) {
		$this->_view = $view;
	}

	public function footer()
    {
        $view = new Zend_View();
        $registry = Zend_Registry::getInstance();
        $this->db = $registry->get('db');
        $hotelarr=$this->db->fetchAll(" select * from hotels where is_Enabled=1 order by rand() limit 0,5");
        $abtsrilankaarr=$this->db->fetchAll(" select * from about_country  where status=1 order by rand() limit 0,5 ");
        $toursarr=$this->db->fetchAll(" select * from tours  where status=1 order by rand() limit 0,5 ");
        $excursionsarr=$this->db->fetchAll(" select * from excursion  where active=1 order by rand() limit 0,5 ");
        //$toursarr=$this->db->fetchAll(" select * from tours  where status=1 order by rand() limit 0,5 ");
       // print_r($hotelarr);exit;
?>
<!-- Footer start  -->

  <div id="footer-aria">
  	<!-- footer menu start -->
    <ul>
	   <li><a href="/index/about/">About Us</a></li>
	   <li><a href="/index/contact/">Contact Us</a></li>
	   <li><a href="#">About Sri Lanka</a>
	      <ul>
                  <?php foreach($abtsrilankaarr as $slarr):?>
		  	<li><a href="/aboutcountry/view/page_id/<?php echo $slarr["tour_id"];?>#map1"><?php echo $slarr["title"];?></a></li>
                  <?php endforeach;?>
		  </ul>
	   </li>
	  <li><a href="/hotel/view/">Reservations</a></li>
	</ul>
    <ul>
	   <li><a href="#">Tours</a>
	      <ul>
		  	 <?php foreach($toursarr as $tarr):?>
		  	<li><a href="/tour/view/tour_id/<?php echo $tarr["tour_id"];?>"><?php echo $tarr["tour_title"];?></a></li>
                  <?php endforeach;?>
		  </ul>
	   </li>
	</ul>
    <ul>
	   <li><a href="#">Hotels</a>
	      <ul>
		  	 <?php foreach($hotelarr as $harr):?>
		  	<li><a href="/hotel/details/hotelid/<?php echo $harr["hotel_id"];?>"><?php echo $harr["hotel_title"];?></a></li>
                  <?php endforeach;?>
		  </ul>
	   </li>
	</ul>
    <ul>
	   <li><a href="#">Excursions</a>
	      <ul>
		  	 <?php foreach($excursionsarr as $exarr):?>
		  	<li><a href="/escursions/id/<?php echo $exarr["id"];?>"><?php echo $exarr["id"];?></a></li>
                  <?php endforeach;?>
		  </ul>
	   </li>
	</ul>
    <ul>
	   <li><a href="#">Destinations</a>
	      <ul>
		  	 
		  	<li><a href="/destinations/id/1">Sri Lanka</a></li>
                        <li><a href="/destinations/id/2">Maldives</a></li>

		  </ul>
	   </li>
	</ul><!-- footer menu end -->
	<!-- copyright aria start -->
	<div class="copyright">
	  <p>Copyright <b>&copy;</b> 2011 Warner Travellers (pvt) Ltd</p><br/>
	  <p>All rights reserved.  |  <a href="#">Privacy Polocy</a></p>
	</div><!-- copyright aria end -->
  </div>

<!-- Footer end  -->






<?php
    }
}
?>